CREATE TABLE [dbo].[T_PRODUCT_PRESENTATION_BRAND]
(
[PRODUCT_ID] [bigint] NOT NULL,
[PRODUCT_PRESENTATION_ID] [int] NOT NULL,
[CREATE_DATE] [datetime] NOT NULL,
[DISABLE_DATE] [datetime] NULL,
[BRAND_ID] [bigint] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[T_PRODUCT_PRESENTATION_BRAND] ADD CONSTRAINT [PK__T_PRODUC__6BCC613C45E50E2D] PRIMARY KEY CLUSTERED  ([PRODUCT_ID], [PRODUCT_PRESENTATION_ID], [BRAND_ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[T_PRODUCT_PRESENTATION_BRAND] ADD CONSTRAINT [FK__T_PRODUCT__BRAND__72C60C4A] FOREIGN KEY ([BRAND_ID]) REFERENCES [dbo].[T_BRAND] ([BRAND_ID])
GO
ALTER TABLE [dbo].[T_PRODUCT_PRESENTATION_BRAND] ADD CONSTRAINT [FK__PRODUCT_P__PRODU__05A3D694] FOREIGN KEY ([PRODUCT_ID]) REFERENCES [dbo].[T_PRODUCT] ([PRODUCT_ID])
GO
ALTER TABLE [dbo].[T_PRODUCT_PRESENTATION_BRAND] ADD CONSTRAINT [FK__T_PRODUCT__PRODU__5EBF139D] FOREIGN KEY ([PRODUCT_PRESENTATION_ID]) REFERENCES [dbo].[T_PRODUCT_PRESENTATION] ([PRODUCT_PRESENTATION_ID])
GO
